﻿
CREATE PROCEDURE [dbo].[SYS_Provider_ADD]
(
	@ProviderTypeId  int,
	@Name  varchar(50),
	@Description  varchar(8000),
	@ConfigurationControlPath  varchar(200),
	@CreateBy int,
	@ProviderId int OUTPUT
)

AS

INSERT INTO SYS_Provider
(
	[ProviderTypeId],
	[Name],
	[Description],
	[ConfigurationControlPath],
	[Status],
	[rowGUID],
	[CreateBy],
	[UpdateBy],
	[CreateDate],
	[UpdateDate]
)
VALUES
(
	@ProviderTypeId,
	@Name,
	@Description,
	@ConfigurationControlPath,
	1,
	newid(),
	@CreateBy,
	@CreateBy,
	getdate(),
	getdate()
)

SET @ProviderId = SCOPE_IDENTITY();

--#endregion

